Tabela OncologyAddPerfTest

Definicja tabeli OncologyAddPerfTest

Name

OncologyAddPerfTest

Code

OncologyAddPerfTest

Comment

Tabela do zapisu badan nie wymienionych w liscie dla diagnostyki podstawowej i szpitala, beda zapisywane tekstowo gdyz nie wszystkie badania z tabeli Service beda dostepne/wykonywane we wszystkich szpitalach


Lista kolumn tabeli OncologyAddPerfTest

Name

Code

OncologyAddPerfTestID

OncologyAddPerfTestID

OncologicCardID

OncologicCardID

OncologyBasicID

OncologyBasicID

OncologyHospitalID

OncologyHospitalID

PerfTest

PerfTest

PerfDT

PerfDT

Comments

Comments


Kolumna OncologyAddPerfTestID tabeli OncologyAddPerfTest

Definicja kolumny OncologyAddPerfTestID tabeli OncologyAddPerfTest

Name

OncologyAddPerfTestID

Code

OncologyAddPerfTestID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

klucz glówny


Kolumna OncologicCardID tabeli OncologyAddPerfTest

Definicja kolumny OncologicCardID tabeli OncologyAddPerfTest

Name

OncologicCardID

Code

OncologicCardID

Data Type

NUMBER(10)

Mandatory

No

Comment

id karty


Kolumna OncologyBasicID tabeli OncologyAddPerfTest

Definicja kolumny OncologyBasicID tabeli OncologyAddPerfTest

Name

OncologyBasicID

Code

OncologyBasicID

Data Type

NUMBER(10)

Mandatory

No

Comment

id wpisu w tabeli diganostyki podstawowej


Kolumna OncologyHospitalID tabeli OncologyAddPerfTest

Definicja kolumny OncologyHospitalID tabeli OncologyAddPerfTest

Name

OncologyHospitalID

Code

OncologyHospitalID

Data Type

NUMBER(10)

Mandatory

No

Comment

id wpisu w tabeli diagnostyki szpitalnej


Kolumna PerfTest tabeli OncologyAddPerfTest

Definicja kolumny PerfTest tabeli OncologyAddPerfTest

Name

PerfTest

Code

PerfTest

Data Type

VARCHAR2(100)

Mandatory

No

Comment

nazwa badania


Kolumna PerfDT tabeli OncologyAddPerfTest

Definicja kolumny PerfDT tabeli OncologyAddPerfTest

Name

PerfDT

Code

PerfDT

Data Type

DATE

Mandatory

No

Comment

data wykonania


Kolumna Comments tabeli OncologyAddPerfTest

Definicja kolumny Comments tabeli OncologyAddPerfTest

Name

Comments

Code

Comments

Data Type

VARCHAR2(100)

Mandatory

No

Comment

uwagi


Lista kluczy tabeli OncologyAddPerfTest

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli OncologyAddPerfTest

Definicja klucza Identifier_1 tabeli OncologyAddPerfTest

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment